﻿CREATE TABLE [dbo].[AngajatiBoli] (
    [IDPersoana]          INT             NOT NULL,
    [IDAngajatSalarizare] INT             NOT NULL,
    [IDTipBoala]          SMALLINT        NOT NULL,
    [Luna]                SMALLINT        CONSTRAINT [DF_AngajatiBoli_Luna] DEFAULT ((1)) NOT NULL,
    [Anul]                SMALLINT        CONSTRAINT [DF_AngajatiBoli_Anul] DEFAULT ((2000)) NOT NULL,
    [Valoare]             DECIMAL (18, 2) CONSTRAINT [DF_AngajatiBoli_Valoare] DEFAULT ((0)) NOT NULL,
    [ZileBoala]           DECIMAL (18, 2) DEFAULT ((0)) NOT NULL,
    CONSTRAINT [FK_AngajatiBoli_AngajatiSalarizare] FOREIGN KEY ([IDAngajatSalarizare]) REFERENCES [dbo].[AngajatiSalarizare] ([IDAngajatSalarizare]),
    CONSTRAINT [FK_AngajatiBoli_Persoane] FOREIGN KEY ([IDPersoana]) REFERENCES [dbo].[Persoane] ([IdPersoana])
);

